<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>个税申报表的处理与合并</title>
	<link rel="stylesheet" type="text/css" href="kendo.common.min.css">
	<link rel="stylesheet" type="text/css" href="kendo.silver.min.css">
	<style type="text/css" media="screen">
		*{padding: 0;margin: 0;}
	</style>
</head>
<body>
	<div id="spreadsheet1" class="spreadsheet" style="width: 100%;height:1200px;"></div>
	<div id="spreadsheet2" class="spreadsheet" style="width: 100%;height:1200px;"></div>
	<div id="spreadsheet3" class="spreadsheet" style="width: 100%;height:1200px;"></div>
	<div id="spreadsheet4" class="spreadsheet" style="width: 100%;height:1200px;"></div>
	<div id="spreadsheet5" class="spreadsheet" style="width: 100%;height:1200px;"></div>
	<div id="spreadsheet6" class="spreadsheet" style="width: 100%;height:1200px;"></div>
	<script src="jquery.js"></script>
	<script src="kendo.custom.js"></script>
	<script src="jszip.min.js"></script>
	<script>
		$(".spreadsheet").kendoSpreadsheet();

		var spreadsheet1 = $('#spreadsheet1').data("kendoSpreadsheet").toJSON()
		spreadsheet1.sheets[0].rows = spreadsheet1.sheets[0].rows.splice(0, 62);

		var spreadsheet2 = $('#spreadsheet2').data("kendoSpreadsheet").toJSON()
		spreadsheet2.sheets[0].rows = spreadsheet2.sheets[0].rows.splice(0, 11);
		console.log(spreadsheet2)

		var spreadsheet3 = $('#spreadsheet3').data("kendoSpreadsheet").toJSON()
		spreadsheet3.sheets[0].rows = spreadsheet3.sheets[0].rows.splice(0, 11);
		console.log(spreadsheet3)

		var spreadsheet4 = $('#spreadsheet4').data("kendoSpreadsheet").toJSON()
		spreadsheet4.sheets[0].rows = spreadsheet4.sheets[0].rows.splice(0, 11);
		console.log(spreadsheet4)

		var spreadsheet5 = $('#spreadsheet5').data("kendoSpreadsheet").toJSON()
		spreadsheet5.sheets[0].rows = spreadsheet5.sheets[0].rows.splice(0, 11);
		console.log(spreadsheet5)

		var spreadsheet6 = $('#spreadsheet6').data("kendoSpreadsheet").toJSON();
		console.log(spreadsheet6)

		spreadsheet1.sheets.push(spreadsheet2.sheets[0], spreadsheet3.sheets[0], spreadsheet4.sheets[0], spreadsheet5.sheets[0], spreadsheet6.sheets[0])


		console.log(spreadsheet1)
		$('#spreadsheet1').data("kendoSpreadsheet").fromJSON(spreadsheet1);
	</script>
</body>
</html>